/**
 *  GTUG Zaragoza
 *  http://zaragoza.gtugs.org/
 *
 *  This program is free software: you can redistribute it and/or modify
 *  it under the terms of the GNU General Public License as published by
 *  the Free Software Foundation, either version 3 of the License, or
 *  (at your option) any later version.
 *
 *  This program is distributed in the hope that it will be useful,
 *  but WITHOUT ANY WARRANTY; without even the implied warranty of
 *  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 *  GNU General Public License for more details.
 *
 *  You should have received a copy of the GNU General Public License
 *  along with this program.  If not, see <http://www.gnu.org/licenses/>.
 */
package org.gtugs.zaragoza.feeds.provider;

import org.gtugs.zaragoza.feeds.FeedEntry;

import android.content.Context;
import android.database.sqlite.SQLiteDatabase;
import android.database.sqlite.SQLiteOpenHelper;

class DatabaseHelper extends SQLiteOpenHelper {

    private static final String DATABASE_NAME = "gtug_zaragoza";
    private static final int DATABASE_VERSION = 4;

    DatabaseHelper(Context context) {

        // calls the super constructor, requesting the default cursor factory.
        super(context, DATABASE_NAME, null, DATABASE_VERSION);
    }


    @Override
    public void onCreate(SQLiteDatabase db) {
        db.execSQL("CREATE TABLE "+ FeedEntry.class.getSimpleName() +" ("
               
        		+ FeedEntry._ID + " INTEGER PRIMARY KEY AUTOINCREMENT,"
        		+ FeedEntry.ID + " TEXT UNIQUE,"
                + FeedEntry.AUTHOR_EMAIL + " TEXT,"
                + FeedEntry.AUTHOR_NAME + " TEXT,"
                + FeedEntry.LINK + " TEXT,"
                + FeedEntry.SUMMARY + " TEXT,"
                + FeedEntry.TITLE + " TEXT,"
                + FeedEntry.UPDATED + " TEXT "
                + ");");
    }

    /**
     *
     * Demonstrates that the provider must consider what happens when the
     * underlying datastore is changed. In this sample, the database is upgraded the database
     * by destroying the existing data.
     * A real application should upgrade the database in place.
     */
    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {

        // Kills the table and existing data
        db.execSQL("DROP TABLE IF EXISTS "+ FeedEntry.class.getSimpleName());

        // Recreates the database with a new version
        onCreate(db);
    }
}
